const List = {
  // 查询分类左侧数据
  selectListLeftData(option) {
    return `select * from home`
  },
  // 查询分类右侧数据
  selectListRightData(option) {
    return `select topic_id, text,good_id,shopName,price,monthNum,shopImgUrl from list ,list_information where topic_id=good_topic_id`
  },

  selectItemData(option) {
    return `select * from list_information where good_id=${option}`
  },

  selectPics(option) {
    return `select pic_src from list_src where pic_list_id=${option}`
  },

  // 查询推荐数据
  selectInit(option) {
    return `select * from list_information where good_topic_id=1`
  },

  // 查询用户id
  selectUserId(option) {
    return `SELECT user_id from user where user_phone=${option.tel}`
  },
  // 查用用户购买的数据
  selectUserGoPay(option) {
    return `select ordernumber_user_id,orderfrom_list_id from ordernumber,orderfrom where id=orderfrom_ordernumber_id and ordernumber_status=3 `
  },

  // 查询推荐数据
  selectRecommedData(id) {
    return `select * from list_information where good_id=${id}`
  },
}

exports = module.exports = List
